package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderOutstockCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public OrderOutstockCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOutIdIsNull() {
            addCriterion("OUT_ID is null");
            return (Criteria) this;
        }

        public Criteria andOutIdIsNotNull() {
            addCriterion("OUT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOutIdEqualTo(Integer value) {
            addCriterion("OUT_ID =", value, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdNotEqualTo(Integer value) {
            addCriterion("OUT_ID <>", value, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdGreaterThan(Integer value) {
            addCriterion("OUT_ID >", value, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("OUT_ID >=", value, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdLessThan(Integer value) {
            addCriterion("OUT_ID <", value, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdLessThanOrEqualTo(Integer value) {
            addCriterion("OUT_ID <=", value, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdIn(List<Integer> values) {
            addCriterion("OUT_ID in", values, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdNotIn(List<Integer> values) {
            addCriterion("OUT_ID not in", values, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdBetween(Integer value1, Integer value2) {
            addCriterion("OUT_ID between", value1, value2, "outId");
            return (Criteria) this;
        }

        public Criteria andOutIdNotBetween(Integer value1, Integer value2) {
            addCriterion("OUT_ID not between", value1, value2, "outId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNull() {
            addCriterion("O_INDATE is null");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNotNull() {
            addCriterion("O_INDATE is not null");
            return (Criteria) this;
        }

        public Criteria andOIndateEqualTo(Date value) {
            addCriterion("O_INDATE =", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotEqualTo(Date value) {
            addCriterion("O_INDATE <>", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThan(Date value) {
            addCriterion("O_INDATE >", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThanOrEqualTo(Date value) {
            addCriterion("O_INDATE >=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThan(Date value) {
            addCriterion("O_INDATE <", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThanOrEqualTo(Date value) {
            addCriterion("O_INDATE <=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateIn(List<Date> values) {
            addCriterion("O_INDATE in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotIn(List<Date> values) {
            addCriterion("O_INDATE not in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateBetween(Date value1, Date value2) {
            addCriterion("O_INDATE between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotBetween(Date value1, Date value2) {
            addCriterion("O_INDATE not between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andCreaterIsNull() {
            addCriterion("CREATER is null");
            return (Criteria) this;
        }

        public Criteria andCreaterIsNotNull() {
            addCriterion("CREATER is not null");
            return (Criteria) this;
        }

        public Criteria andCreaterEqualTo(String value) {
            addCriterion("CREATER =", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotEqualTo(String value) {
            addCriterion("CREATER <>", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterGreaterThan(String value) {
            addCriterion("CREATER >", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterGreaterThanOrEqualTo(String value) {
            addCriterion("CREATER >=", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterLessThan(String value) {
            addCriterion("CREATER <", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterLessThanOrEqualTo(String value) {
            addCriterion("CREATER <=", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterLike(String value) {
            addCriterion("CREATER like", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotLike(String value) {
            addCriterion("CREATER not like", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterIn(List<String> values) {
            addCriterion("CREATER in", values, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotIn(List<String> values) {
            addCriterion("CREATER not in", values, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterBetween(String value1, String value2) {
            addCriterion("CREATER between", value1, value2, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotBetween(String value1, String value2) {
            addCriterion("CREATER not between", value1, value2, "creater");
            return (Criteria) this;
        }

        public Criteria andOutIntentIsNull() {
            addCriterion("OUT_INTENT is null");
            return (Criteria) this;
        }

        public Criteria andOutIntentIsNotNull() {
            addCriterion("OUT_INTENT is not null");
            return (Criteria) this;
        }

        public Criteria andOutIntentEqualTo(Integer value) {
            addCriterion("OUT_INTENT =", value, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentNotEqualTo(Integer value) {
            addCriterion("OUT_INTENT <>", value, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentGreaterThan(Integer value) {
            addCriterion("OUT_INTENT >", value, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentGreaterThanOrEqualTo(Integer value) {
            addCriterion("OUT_INTENT >=", value, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentLessThan(Integer value) {
            addCriterion("OUT_INTENT <", value, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentLessThanOrEqualTo(Integer value) {
            addCriterion("OUT_INTENT <=", value, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentIn(List<Integer> values) {
            addCriterion("OUT_INTENT in", values, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentNotIn(List<Integer> values) {
            addCriterion("OUT_INTENT not in", values, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentBetween(Integer value1, Integer value2) {
            addCriterion("OUT_INTENT between", value1, value2, "outIntent");
            return (Criteria) this;
        }

        public Criteria andOutIntentNotBetween(Integer value1, Integer value2) {
            addCriterion("OUT_INTENT not between", value1, value2, "outIntent");
            return (Criteria) this;
        }

        public Criteria andExpTimeIsNull() {
            addCriterion("EXP_TIME is null");
            return (Criteria) this;
        }

        public Criteria andExpTimeIsNotNull() {
            addCriterion("EXP_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andExpTimeEqualTo(Date value) {
            addCriterion("EXP_TIME =", value, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeNotEqualTo(Date value) {
            addCriterion("EXP_TIME <>", value, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeGreaterThan(Date value) {
            addCriterion("EXP_TIME >", value, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("EXP_TIME >=", value, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeLessThan(Date value) {
            addCriterion("EXP_TIME <", value, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeLessThanOrEqualTo(Date value) {
            addCriterion("EXP_TIME <=", value, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeIn(List<Date> values) {
            addCriterion("EXP_TIME in", values, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeNotIn(List<Date> values) {
            addCriterion("EXP_TIME not in", values, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeBetween(Date value1, Date value2) {
            addCriterion("EXP_TIME between", value1, value2, "expTime");
            return (Criteria) this;
        }

        public Criteria andExpTimeNotBetween(Date value1, Date value2) {
            addCriterion("EXP_TIME not between", value1, value2, "expTime");
            return (Criteria) this;
        }

        public Criteria andOStatusIsNull() {
            addCriterion("O_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andOStatusIsNotNull() {
            addCriterion("O_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOStatusEqualTo(Integer value) {
            addCriterion("O_STATUS =", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotEqualTo(Integer value) {
            addCriterion("O_STATUS <>", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusGreaterThan(Integer value) {
            addCriterion("O_STATUS >", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("O_STATUS >=", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusLessThan(Integer value) {
            addCriterion("O_STATUS <", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusLessThanOrEqualTo(Integer value) {
            addCriterion("O_STATUS <=", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusIn(List<Integer> values) {
            addCriterion("O_STATUS in", values, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotIn(List<Integer> values) {
            addCriterion("O_STATUS not in", values, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusBetween(Integer value1, Integer value2) {
            addCriterion("O_STATUS between", value1, value2, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("O_STATUS not between", value1, value2, "oStatus");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNull() {
            addCriterion("CEXT_ID is null");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNotNull() {
            addCriterion("CEXT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCextIdEqualTo(Integer value) {
            addCriterion("CEXT_ID =", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotEqualTo(Integer value) {
            addCriterion("CEXT_ID <>", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThan(Integer value) {
            addCriterion("CEXT_ID >", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID >=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThan(Integer value) {
            addCriterion("CEXT_ID <", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID <=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdIn(List<Integer> values) {
            addCriterion("CEXT_ID in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotIn(List<Integer> values) {
            addCriterion("CEXT_ID not in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID not between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNull() {
            addCriterion("CPERSON is null");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNotNull() {
            addCriterion("CPERSON is not null");
            return (Criteria) this;
        }

        public Criteria andCpersonEqualTo(String value) {
            addCriterion("CPERSON =", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotEqualTo(String value) {
            addCriterion("CPERSON <>", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThan(String value) {
            addCriterion("CPERSON >", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThanOrEqualTo(String value) {
            addCriterion("CPERSON >=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThan(String value) {
            addCriterion("CPERSON <", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThanOrEqualTo(String value) {
            addCriterion("CPERSON <=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLike(String value) {
            addCriterion("CPERSON like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotLike(String value) {
            addCriterion("CPERSON not like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonIn(List<String> values) {
            addCriterion("CPERSON in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotIn(List<String> values) {
            addCriterion("CPERSON not in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonBetween(String value1, String value2) {
            addCriterion("CPERSON between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotBetween(String value1, String value2) {
            addCriterion("CPERSON not between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andCidIsNull() {
            addCriterion("CID is null");
            return (Criteria) this;
        }

        public Criteria andCidIsNotNull() {
            addCriterion("CID is not null");
            return (Criteria) this;
        }

        public Criteria andCidEqualTo(Integer value) {
            addCriterion("CID =", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotEqualTo(Integer value) {
            addCriterion("CID <>", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThan(Integer value) {
            addCriterion("CID >", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CID >=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThan(Integer value) {
            addCriterion("CID <", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThanOrEqualTo(Integer value) {
            addCriterion("CID <=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidIn(List<Integer> values) {
            addCriterion("CID in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotIn(List<Integer> values) {
            addCriterion("CID not in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidBetween(Integer value1, Integer value2) {
            addCriterion("CID between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotBetween(Integer value1, Integer value2) {
            addCriterion("CID not between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNull() {
            addCriterion("CPHONE is null");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNotNull() {
            addCriterion("CPHONE is not null");
            return (Criteria) this;
        }

        public Criteria andCphoneEqualTo(String value) {
            addCriterion("CPHONE =", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotEqualTo(String value) {
            addCriterion("CPHONE <>", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThan(String value) {
            addCriterion("CPHONE >", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThanOrEqualTo(String value) {
            addCriterion("CPHONE >=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThan(String value) {
            addCriterion("CPHONE <", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThanOrEqualTo(String value) {
            addCriterion("CPHONE <=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLike(String value) {
            addCriterion("CPHONE like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotLike(String value) {
            addCriterion("CPHONE not like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneIn(List<String> values) {
            addCriterion("CPHONE in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotIn(List<String> values) {
            addCriterion("CPHONE not in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneBetween(String value1, String value2) {
            addCriterion("CPHONE between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotBetween(String value1, String value2) {
            addCriterion("CPHONE not between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodIsNull() {
            addCriterion("DELIVER_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodIsNotNull() {
            addCriterion("DELIVER_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodEqualTo(Integer value) {
            addCriterion("DELIVER_METHOD =", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodNotEqualTo(Integer value) {
            addCriterion("DELIVER_METHOD <>", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodGreaterThan(Integer value) {
            addCriterion("DELIVER_METHOD >", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("DELIVER_METHOD >=", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodLessThan(Integer value) {
            addCriterion("DELIVER_METHOD <", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodLessThanOrEqualTo(Integer value) {
            addCriterion("DELIVER_METHOD <=", value, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodIn(List<Integer> values) {
            addCriterion("DELIVER_METHOD in", values, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodNotIn(List<Integer> values) {
            addCriterion("DELIVER_METHOD not in", values, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodBetween(Integer value1, Integer value2) {
            addCriterion("DELIVER_METHOD between", value1, value2, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andDeliverMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("DELIVER_METHOD not between", value1, value2, "deliverMethod");
            return (Criteria) this;
        }

        public Criteria andLStatusIsNull() {
            addCriterion("L_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andLStatusIsNotNull() {
            addCriterion("L_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andLStatusEqualTo(Integer value) {
            addCriterion("L_STATUS =", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusNotEqualTo(Integer value) {
            addCriterion("L_STATUS <>", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusGreaterThan(Integer value) {
            addCriterion("L_STATUS >", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("L_STATUS >=", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusLessThan(Integer value) {
            addCriterion("L_STATUS <", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusLessThanOrEqualTo(Integer value) {
            addCriterion("L_STATUS <=", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusIn(List<Integer> values) {
            addCriterion("L_STATUS in", values, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusNotIn(List<Integer> values) {
            addCriterion("L_STATUS not in", values, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusBetween(Integer value1, Integer value2) {
            addCriterion("L_STATUS between", value1, value2, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("L_STATUS not between", value1, value2, "lStatus");
            return (Criteria) this;
        }

        public Criteria andEMoneyIsNull() {
            addCriterion("E_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andEMoneyIsNotNull() {
            addCriterion("E_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andEMoneyEqualTo(Double value) {
            addCriterion("E_MONEY =", value, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyNotEqualTo(Double value) {
            addCriterion("E_MONEY <>", value, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyGreaterThan(Double value) {
            addCriterion("E_MONEY >", value, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("E_MONEY >=", value, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyLessThan(Double value) {
            addCriterion("E_MONEY <", value, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyLessThanOrEqualTo(Double value) {
            addCriterion("E_MONEY <=", value, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyIn(List<Double> values) {
            addCriterion("E_MONEY in", values, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyNotIn(List<Double> values) {
            addCriterion("E_MONEY not in", values, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyBetween(Double value1, Double value2) {
            addCriterion("E_MONEY between", value1, value2, "eMoney");
            return (Criteria) this;
        }

        public Criteria andEMoneyNotBetween(Double value1, Double value2) {
            addCriterion("E_MONEY not between", value1, value2, "eMoney");
            return (Criteria) this;
        }

        public Criteria andOSTimeIsNull() {
            addCriterion("O_S_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOSTimeIsNotNull() {
            addCriterion("O_S_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOSTimeEqualTo(Date value) {
            addCriterion("O_S_TIME =", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeNotEqualTo(Date value) {
            addCriterion("O_S_TIME <>", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeGreaterThan(Date value) {
            addCriterion("O_S_TIME >", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("O_S_TIME >=", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeLessThan(Date value) {
            addCriterion("O_S_TIME <", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeLessThanOrEqualTo(Date value) {
            addCriterion("O_S_TIME <=", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeIn(List<Date> values) {
            addCriterion("O_S_TIME in", values, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeNotIn(List<Date> values) {
            addCriterion("O_S_TIME not in", values, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeBetween(Date value1, Date value2) {
            addCriterion("O_S_TIME between", value1, value2, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeNotBetween(Date value1, Date value2) {
            addCriterion("O_S_TIME not between", value1, value2, "oSTime");
            return (Criteria) this;
        }

        public Criteria andECompanyIsNull() {
            addCriterion("E_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andECompanyIsNotNull() {
            addCriterion("E_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andECompanyEqualTo(String value) {
            addCriterion("E_COMPANY =", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyNotEqualTo(String value) {
            addCriterion("E_COMPANY <>", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyGreaterThan(String value) {
            addCriterion("E_COMPANY >", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyGreaterThanOrEqualTo(String value) {
            addCriterion("E_COMPANY >=", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyLessThan(String value) {
            addCriterion("E_COMPANY <", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyLessThanOrEqualTo(String value) {
            addCriterion("E_COMPANY <=", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyLike(String value) {
            addCriterion("E_COMPANY like", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyNotLike(String value) {
            addCriterion("E_COMPANY not like", value, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyIn(List<String> values) {
            addCriterion("E_COMPANY in", values, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyNotIn(List<String> values) {
            addCriterion("E_COMPANY not in", values, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyBetween(String value1, String value2) {
            addCriterion("E_COMPANY between", value1, value2, "eCompany");
            return (Criteria) this;
        }

        public Criteria andECompanyNotBetween(String value1, String value2) {
            addCriterion("E_COMPANY not between", value1, value2, "eCompany");
            return (Criteria) this;
        }

        public Criteria andENumberIsNull() {
            addCriterion("E_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andENumberIsNotNull() {
            addCriterion("E_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andENumberEqualTo(String value) {
            addCriterion("E_NUMBER =", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberNotEqualTo(String value) {
            addCriterion("E_NUMBER <>", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberGreaterThan(String value) {
            addCriterion("E_NUMBER >", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberGreaterThanOrEqualTo(String value) {
            addCriterion("E_NUMBER >=", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberLessThan(String value) {
            addCriterion("E_NUMBER <", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberLessThanOrEqualTo(String value) {
            addCriterion("E_NUMBER <=", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberLike(String value) {
            addCriterion("E_NUMBER like", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberNotLike(String value) {
            addCriterion("E_NUMBER not like", value, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberIn(List<String> values) {
            addCriterion("E_NUMBER in", values, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberNotIn(List<String> values) {
            addCriterion("E_NUMBER not in", values, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberBetween(String value1, String value2) {
            addCriterion("E_NUMBER between", value1, value2, "eNumber");
            return (Criteria) this;
        }

        public Criteria andENumberNotBetween(String value1, String value2) {
            addCriterion("E_NUMBER not between", value1, value2, "eNumber");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeIsNull() {
            addCriterion("UNIQUE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeIsNotNull() {
            addCriterion("UNIQUE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeEqualTo(Long value) {
            addCriterion("UNIQUE_CODE =", value, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeNotEqualTo(Long value) {
            addCriterion("UNIQUE_CODE <>", value, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeGreaterThan(Long value) {
            addCriterion("UNIQUE_CODE >", value, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeGreaterThanOrEqualTo(Long value) {
            addCriterion("UNIQUE_CODE >=", value, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeLessThan(Long value) {
            addCriterion("UNIQUE_CODE <", value, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeLessThanOrEqualTo(Long value) {
            addCriterion("UNIQUE_CODE <=", value, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeIn(List<Long> values) {
            addCriterion("UNIQUE_CODE in", values, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeNotIn(List<Long> values) {
            addCriterion("UNIQUE_CODE not in", values, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeBetween(Long value1, Long value2) {
            addCriterion("UNIQUE_CODE between", value1, value2, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andUniqueCodeNotBetween(Long value1, Long value2) {
            addCriterion("UNIQUE_CODE not between", value1, value2, "uniqueCode");
            return (Criteria) this;
        }

        public Criteria andTPersonIsNull() {
            addCriterion("T_PERSON is null");
            return (Criteria) this;
        }

        public Criteria andTPersonIsNotNull() {
            addCriterion("T_PERSON is not null");
            return (Criteria) this;
        }

        public Criteria andTPersonEqualTo(String value) {
            addCriterion("T_PERSON =", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonNotEqualTo(String value) {
            addCriterion("T_PERSON <>", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonGreaterThan(String value) {
            addCriterion("T_PERSON >", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonGreaterThanOrEqualTo(String value) {
            addCriterion("T_PERSON >=", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonLessThan(String value) {
            addCriterion("T_PERSON <", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonLessThanOrEqualTo(String value) {
            addCriterion("T_PERSON <=", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonLike(String value) {
            addCriterion("T_PERSON like", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonNotLike(String value) {
            addCriterion("T_PERSON not like", value, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonIn(List<String> values) {
            addCriterion("T_PERSON in", values, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonNotIn(List<String> values) {
            addCriterion("T_PERSON not in", values, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonBetween(String value1, String value2) {
            addCriterion("T_PERSON between", value1, value2, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTPersonNotBetween(String value1, String value2) {
            addCriterion("T_PERSON not between", value1, value2, "tPerson");
            return (Criteria) this;
        }

        public Criteria andTTimeIsNull() {
            addCriterion("T_TIME is null");
            return (Criteria) this;
        }

        public Criteria andTTimeIsNotNull() {
            addCriterion("T_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andTTimeEqualTo(Date value) {
            addCriterion("T_TIME =", value, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeNotEqualTo(Date value) {
            addCriterion("T_TIME <>", value, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeGreaterThan(Date value) {
            addCriterion("T_TIME >", value, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("T_TIME >=", value, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeLessThan(Date value) {
            addCriterion("T_TIME <", value, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeLessThanOrEqualTo(Date value) {
            addCriterion("T_TIME <=", value, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeIn(List<Date> values) {
            addCriterion("T_TIME in", values, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeNotIn(List<Date> values) {
            addCriterion("T_TIME not in", values, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeBetween(Date value1, Date value2) {
            addCriterion("T_TIME between", value1, value2, "tTime");
            return (Criteria) this;
        }

        public Criteria andTTimeNotBetween(Date value1, Date value2) {
            addCriterion("T_TIME not between", value1, value2, "tTime");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ORDER_OUTSTOCK
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}